<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Viewing specific rows and columns: Filter on Selections</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
p.whs2 { margin-left:0px; }
ul.whs3 { list-style:disc; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs2 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nRestricting report results: Filtering\nDisplaying or hiding rows and columns: Filter on Selections");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Viewing specific rows and columns: Filter on Selections</h1>
<p class=seealso>You can determine which rows and columns of data are displayed 
 or hidden on a report. For example, if a report has more rows of information 
 than you wish to view, you can specify which rows to hide. </p>
<p class=seealso><span style="font-weight: bold;"><B>Note</B></span>: This setting 
 will not affect how the report data is calculated, as the hidden rows 
 and columns are still part of the reports definition and therefore are 
 part of the data calculations. If you own MicroStrategy OLAP Services, 
 any hidden rows and columns are still visible. </p>
<p class=seealso><span style="font-weight: bold;"><B>Warning: </B></span>If you 
 use Filter on Selections on an attribute that includes derived elements, 
 a new derived element and view filter qualifications are created to support 
 the filtering action. This restricts the data that is available on the 
 report. If after taking this action you want to display all information 
 available on the report, you must clear the view filter as well as remove 
 the derived elements defined for the attribute. </p>
<h2>To display or hide rows and columns</h2>
<ol type="1" class="whs1">
	
<li class=p><p class="whs2">Click the name of a report 
 to execute it.</p></li>
	
<li class=p><p>Press and hold <span style="font-weight: bold;"><B>CTRL</B></span> 
 and click to select individual rows and columns to keep on the report. 
 Rows and columns you do not select will be removed from the report.</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>If DHTML is 
 disabled, select the check boxes next to each row or column you wish to 
 keep on the report. Rows and columns with check boxes that are cleared 
 will be removed from the report.</p></li>
	</ul>
	
<li class=p><p class="whs2">From the <span style="font-weight: bold;"><B>Data</B></span> 
 menu, select <span style="font-weight: bold;"><B>Filter on Selections</B></span>. 
 The report is displayed with only the rows and columns you selected. If 
 no rows or columns are selected, the option is greyed out. </p></li>
</ol>
<ul><ul type="disc" class="whs3">
		
<li class=p><p>If DHTML is disabled, click the <span style="font-weight: bold;"><B>Go</B></span> 
 icon.</p></li>
	</ul>
</ul>
<p>&nbsp;</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
